package com.shanzhu.beadhouse.dao.mapper;

import com.shanzhu.beadhouse.entity.po.NurseGrade;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 护理等级表 Mapper 接口
 * </p>
 *
  * @author: pjy
 
 */
@Mapper
public interface NurseGradeMapper extends BaseMapper<NurseGrade> {
    @Select("select service_id  \n" +
            "from nurse_item ni\n" +
            "LEFT JOIN service_item si ON si.id= ni.service_id\n" +
            "where grade_id=#{gradeId}\n" +
            "AND si.del_flag='N'")
    List<Long> getServiceIdList(Long gradeId);
}
